package com.daidai.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.daidai.model.Association;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * Author: Mr.Chen
 * Date: 2022/08/01 9:30
 * Description:
 */
@Mapper
public interface AssociationDao extends BaseMapper<Association> {

    @Select("select title from activity ac,(select signatureActivity from  association  where associationId=#{associationId})a where ac.activityId=a.signatureActivity")
    String findSignatureActivityName(int associationId);
}
